This series of menu options allows you to import a list or table of search and replace pairs from an external file. The type of search and replace added, and the options that are set, are predetermined by the last search and replace filter selected. So to set the default options, you must initially select a search and replace filter with the desired options. This can also be done programmatically using the COM interface, or search and replace pairs can be added via the command line using pairs of /S= and /R= options. You can also use a Search/Replace list filter to load a file dynamically.

Import list from Excel

The Excel spreadsheet must have data in Sheet 1, and be formatted with the search term in column A, and the replacement for it in column B. No heading is allowed. The loading process stops when a blank cell is reached in column A. It might look as follows:

Import list from CSV-delimited file

The list is loaded from a CSV-delimited file. Such a file can be created with Notepad, and looks like this:

a,b
"a","b"
"aaaa""bbb","ccccc""dddd""ssss"
a,
a
a,b,c
"a","b","c"
"aaaa""bbb","ccccc""dddd""ssss","sssss""ssss"

Import list from Tab-delimited file

The list is loaded from a Tab-delimited file. Such a file can be created with Notepad, and looks like this:

a       b
aaaabbb cccccdddd ssss

a       

a
a       b      c
 

 Contact Us   Support   Community   Tutorials and User Guides (online)
 © 1999-2005 Crystal Software. All rights reserved.